Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

Insert Delete Update
1) A different join is defined in the UPDATE clause
2) A shortcut INSERT statement to enter the data
3) Adding Multiple Rows to a Table
4) Adding Subqueries to Your DELETE Statements
5) Adding Subqueries to Your UPDATE Statements
6) An UPDATE statement can be qualified by the use of the ORDER BY clause and the LIMIT clause
7) Assign value in select clause
8) Calculation in INSERT clause
9) Calculation in INSERT command
10) Column list in the insert statement
11) Data Changed by Field Syntax When 123 4567 Is Inserted
12) Delete All Threads Except the Last 500
13) Delete by JOIN
14) Delete ignore
15) Delete row with condition
16) Delete rows from multiple tables
17) DELETE statement using the using join delete alternative
18) Delete statement with subquery (ERROR 1093 (HY000)
19) Delete with JOIN 2
20) Delete with where clause
21) Deleting Rows with DELETE
22) Do PLUS calculation in where clause
23) Get the last insert id
24) create an INSERT statement
25) In INSERT statement, the columns names are specified and only the values for those columns are included
26) INSERT IGNORE statement
27) Insert null value
28) INSERT ON DUPLICATE KEY UPDATE
29) Insert record to mysql db
30) Insert statement and date calculation
31) Insert statement without column names
32) Insert three rows together
33) Insert values into multiple rows
34) Inserting Data within One INSERT Statement
35) Joining Tables in a DELETE Statement
36) Joining Tables in an UPDATE Statement
37) Modifying Row Data
38) SET clause uses the Quantity column to specify the new value for that column
39) Simple INSERT clause
40) Table join and insert
41) Update and order
42) UPDATE IGNORE
43) Update records with calculation based on two tables
44) UPDATE statement includes a WHERE clause
45) Update statement using table name alias
46) Update statement with case statement
47) Update statement with subquery (ERROR 1093 (HY000)
48) Update statement with variable (ERROR 1093 (HY000)
49) Update two tables with calculation
50) Update value by calculation
51) Update with condition
52) Update with limit clause
53) Update with limitation and calculation
54) Updates all rows with an InStock value of less than 30
55) Updating a joined table
56) Use INSERT LOW_PRIORITY command
57) Use the SQL statement INSERT to create a record
58) Using DELETE LOW_PRIORITY command
59) Using INSERT DELAYED
60) Using one insert statement to add more than one rows
61) Using the from join delete Alternative to Delete Data
62) Using UPDATE Statements to Modify Data in Joined Tables
63) When you update values in a joined table, you can update more than one value at a time